{smcl}
{txt}{sf}{ul off}{.-}
      name:  {res}<unnamed>
       {txt}log:  {res}C:\Users\gk57526\Dropbox\Executive Particularism (Matt Zarit)\Cooperative Agreements\Empirics\OCTOBER 2020\Output\cooperativeagreements.UQFE.SUPPLEMENTARY ANALYSIS #2.11-07-2020.smcl
  {txt}log type:  {res}smcl
 {txt}opened on:  {res} 7 Nov 2020, 20:07:41
{txt}
{com}. 
. 
. 
. 
. 
. *** ALL COOPERATIVE AGREEMENTS [NEW AWARDS, CONTINUATION OF PREVIOUS AWARDS, & REVISIONS OF EXISTING AWARDS] ***
. 
. 
. *** SUPPLEMENTARY ANALYSES INVOLVING BOTH AGENCY HEAD MANAGERIAL COMPETENCE & AGENCY STAFF TECHNICAL EXPERTISE CONDITIONAL EFFECTS BY PARTER ORGANIZATION TYPE [INCLUDING AGENCY HEAD POLICY EXPERTISE] *** 
. 
. 
. **** ACCESS DATABASE ***
. 
. use "C:\Users\gk57526\Dropbox\Executive Particularism (Matt Zarit)\Cooperative Agreements\Empirics\OCTOBER 2020\Data\cooperativeagreements.grantlevel.MANUSCRIPT MODELS.11-06-2020.dta", replace
{txt}
{com}. 
. 
. 
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. 
. 
. 
. 
. *** OBTAIN DESCRIPTIVE STATISTICS FOR RELEVANT COVARIATES TO COMPUTE POSITIVE INTERQUARTILE UNIT CHANGE ///
> *** IN MANAGERIAL COMPETENCE [zmanage2_abszero] & AGENCY STAFF TECHNICAL EXPERTISE [perc_tech] BASED ON EFFECTIVE SAMPLE [N = 241,730] ***
. 
. quietly xtrifreg fed_funding   zpolicy2_abszero  zmanage2_abszero ceo  privmgt  pctagency_packing perc_prof nongov_recip  ///
> zloyalty2_abszero  electionyear unified pres_party house_majority any_chair house_app house_ways lnnewpop pctpoverty pcincomecd   action_a action_b ///
> ln_l1_recip_grantamt ln_l2_recip_grantamt ln_l3_recip_grantamt   ///
> year_89 year_90 year_91 year_92 year_93 year_94  year_95 year_96 year_97 year_98 year_99 year_00 year_01 year_02 year_03 year_04 year_05 year_06 year_07 year_08, ///
> fe i(subagency) q(05)
{txt}
{com}. *
. *
. *
. 
. 
. *** EXAMINE YEAR TRENDS IN THE VOLUME OF CAs ACROSS ALL AGENCIES IN A GIVEN YEAR [NOTICE: INCREASING SECULAR TREND -- 'FLEXIBLY' CONTROL FOR IN OTHER MODELS USING YEAR FIXED EFFECTS] *** NOTE: FREQUENCY OF CAs RISE THROUGH TIME AS A POLICY ADMINISTRATIVE INSTRUMENT ***
. 
. tab year if e(sample)

       {txt}year {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
       1988 {c |}{res}      5,515        2.28        2.28
{txt}       1989 {c |}{res}      5,014        2.07        4.36
{txt}       1990 {c |}{res}      4,848        2.01        6.36
{txt}       1991 {c |}{res}      5,655        2.34        8.70
{txt}       1992 {c |}{res}      6,181        2.56       11.26
{txt}       1993 {c |}{res}      6,116        2.53       13.79
{txt}       1994 {c |}{res}      8,223        3.40       17.19
{txt}       1995 {c |}{res}      9,559        3.95       21.14
{txt}       1996 {c |}{res}     10,199        4.22       25.36
{txt}       1997 {c |}{res}      9,118        3.77       29.13
{txt}       1998 {c |}{res}     10,249        4.24       33.37
{txt}       1999 {c |}{res}     10,818        4.48       37.85
{txt}       2000 {c |}{res}     11,912        4.93       42.78
{txt}       2001 {c |}{res}     11,779        4.87       47.65
{txt}       2002 {c |}{res}     13,846        5.73       53.38
{txt}       2003 {c |}{res}     16,028        6.63       60.01
{txt}       2004 {c |}{res}     17,661        7.31       67.32
{txt}       2005 {c |}{res}     15,018        6.21       73.53
{txt}       2006 {c |}{res}     14,229        5.89       79.41
{txt}       2007 {c |}{res}     28,324       11.72       91.13
{txt}       2008 {c |}{res}     21,438        8.87      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}    241,730      100.00
{txt}
{com}. 
. *
. *
. *
. 
. *** AGENCY HEAD POLICY EXPERTISE OVER TIME: BIVARIATE LINEAR PREDICTION [AGGREGATE EFFECTIVE SAMPLE & DISAGGREGATED BY PARTNER RECEIPIENT ORGANIZATION TYPE] *** 
. 
. **** NOTE 1A: FOR TIME TO BE SPURIOUS IN THE RELATIONSHIP BETWEEN AGENCY HEAD EXPERTISE AND CA AWARD SIZE, EACH MUST BE UPWARD SLOPING THROUGH TIME ///
> **** I.E., INCREASING AGENCY HEAD POLICY EXPERTISE THROUGH TIME IS SPURIOUSLY RELATED TO CA AWARD SIZE THROUGH TIME ***
. 
. **** NOTE 1B: THE EVIDENCE DOES NOT SUPPORT THIS TIME-SPURIOUS ALTERNATIVE EXPLANATION OF THE FINDINGS REPORTED IN THE MANUSCRIPT [SEE GRAPHS GENERATED BELOW] **** 
. 
. 
. twoway  (lfitci zpolicy2_abszero year if e(sample)) 
{res}{txt}
{com}. *
. *
. twoway  (lfitci zpolicy2_abszero year if e(sample) & nongov_recip==0) 
{res}{txt}
{com}. *
. twoway  (lfitci zpolicy2_abszero year if e(sample) & nongov_recip==1) 
{res}{txt}
{com}. *
. *
. twoway  (lfitci zpolicy2_abszero year if e(sample) & nonprofit_recip==1) 
{res}{txt}
{com}. *
. twoway  (lfitci zpolicy2_abszero year if e(sample) & private_recip==1) 
{res}{txt}
{com}. *
. *
. *
. 
. *** notes on graphics code format for graphs made above. (1) Label Y-Axis "Agency Head Policy Expertise"; (2) Label X-Axis "Year"; (3) Y-Axis Range Set to +1.6 to +2.6 ///
> *** (4) Title Heading "Figure SI-2A".... "Figure SI-2E [five graphs]; (5) Subtitle Heading "Full Sample", "Government Organizations", "Non-Government Organizations", ///
. ***     "Nonprofit Organizations", and "Private Organizations"; (6) Save each graphics file ***     
. 
. 
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. 
. *** NATURAL LOGARITHM OF CA AWARD SIZE OVER TIME: BIVARIATE LINEAR PREDICTION [AGGREGATE EFFECTIVE SAMPLE & DISAGGREGATED BY PARTNER RECEIPIENT ORGANIZATION TYPE] *** 
. *** Note: Natural Logarithm To Address Positive Skewness of these Data Across the Distribtion of the Dependent Variable (see Logged-OLS Conditional Mean Regressions Reported in ///
> ***       Analyses to Complement Quantile Regression Model Estimates)
. 
. twoway  (lfitci ln_fed_funding  year if e(sample))
{res}{txt}
{com}. *
. *
. twoway  (lfitci ln_fed_funding  year if e(sample) & nongov_recip==0)
{res}{txt}
{com}. *
. twoway  (lfitci ln_fed_funding  year if e(sample) & nongov_recip==1)
{res}{txt}
{com}. *
. *
. twoway  (lfitci ln_fed_funding  year if e(sample) & nonprofit_recip==1)
{res}{txt}
{com}. *
. twoway  (lfitci ln_fed_funding  year if e(sample) & private_recip==1)
{res}{txt}
{com}. *
. *
. *
. 
. *** notes on graphics code format for graphs made above. (1) Label Y-Axis "Natural Log of CA Award Size (in Dollars)"; (2) Label X-Axis "Year"; ///
> *** (3) Y-Axis Range Set to +10.2 to +11.33; (4) Title Heading "Figure SI-2F".... "Figure SI-2J [five graphs]; (5) Subtitle Heading "Full Sample", "Government Organizations", ///
. ***     "Non-Government Organizations", "Nonprofit Organizations", and "Private Organizations"; (6) Save each graphics file ***     
. 
. 
. 
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. 
. 
.    
. log close
      {txt}name:  {res}<unnamed>
       {txt}log:  {res}C:\Users\gk57526\Dropbox\Executive Particularism (Matt Zarit)\Cooperative Agreements\Empirics\OCTOBER 2020\Output\cooperativeagreements.UQFE.SUPPLEMENTARY ANALYSIS #2.11-07-2020.smcl
  {txt}log type:  {res}smcl
 {txt}closed on:  {res} 7 Nov 2020, 20:08:28
{txt}{.-}
{smcl}
{txt}{sf}{ul off}